using System;
using System.Collections.Generic;
using System.Text;
using System.Data.SqlClient;
using System.Data;

namespace LibraryManagement.ThongKeSach
{
    class ThongKeSach_DAO
    {
        static SqlConnection sqlcnn;
        static SqlDataAdapter sqlda;
        public void KetNoi()
        { 
            sqlcnn= new SqlConnection("server = HOME\\SQLEXPRESS;database = LibraryManagement;Uid=sa;Pwd=123456;");
            sqlcnn.Open();
        }
        public DataSet truyvan(string chuoitruyvan)
        {
            DataSet ds= new DataSet();
            sqlda = new SqlDataAdapter(chuoitruyvan,sqlcnn);
            sqlda.Fill(ds);
            return ds;
        }
    }
}
